name is a String value which is an Alias for Formulas. The Alias for Formulas is a name you have specified for a level of dimension in an OLAP grid or a cross
Value of a level of dimension in an OLAP grid or cross
GridRowColumnValue returns the value of a specified level of dimension in an OLAP grid or cross
To format cells under a level of dimension in an OLAP grid or cross
The following example is applicable to both Crystal and Basic syntax:
Assume an OLAP grid with Products in the rows, and Regions in the columns.
Suppose you would like to use GridRowcolumnValue to conditionally format cells under Level 1 of the Regions dimension and Level 2 of the Products dimension. In particular, you want to format the font color of the total sales of individual products for all of Europe to be red, and that under North America to be blue.
After setting up the necessary Alias for Formulas, you can then express the formatting condition as: if GridRowColumnValue("Continent") returns "Europe", then you would like the font color of the cells for each Level 2 input of the Products dimension to be red, otherwise, since there are only two continents in this scenario, the font color should be blue.
The cells for all Level 2 inputs for Products combined with all Level 1 inputs for Regions are also selected. Formatting done to one of these cells will be carried over to all other selected cells.
If GridRowColumnValue("Continent") = "Europe" Then crRed Else crBlue
In Basic syntax, the formula will be:
If GridRowColumnValue("Continent") = "Europe" Then formula = crRed Else formula = crBlue
You will see the total sales of individual products for Europe highlighted in red, and the total sales of individual products for North America highlighted in blue.
Seagate Software IMG Holdings, Inc. http://www.seagatesoftware.com Support services: http://support.seagatesoftware.com |